
package com.j2eefast.flowable.bpm.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.j2eefast.flowable.bpm.entity.ProjectClaimEntity;
import com.j2eefast.flowable.bpm.entity.ProjectSanLianEntity;
import com.j2eefast.framework.sys.entity.SysUserEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;


/**
 * <p></p>
 *
 * @author: zhangyuan
 * @date: 2021-04-29 23:47
 * @web: http://www.letukeji.cn
 * @version: 1.0.1
 */

public interface SanLianMapper extends BaseMapper<ProjectSanLianEntity> {
	//三联信息列表
	Page<ProjectSanLianEntity> sanLianList(IPage<?> params,
										   @Param("userId") Long userId,
										   @Param("status") String status,
										   @Param("sanlianNo") String sanlianNo,
										   @Param("fileNumber") String fileNumber,
										   @Param("sql_filter") String sql_filter);


	public  List<ProjectSanLianEntity> sanLianList2(IPage<?> params,
										  @Param("userId") Long userId,
										  @Param("status") String status,
										  @Param("sanlianNo") String sanlianNo,
										  @Param("fileNumber") String fileNumber,
										  @Param("sql_filter") String sql_filter);

	//根据id获取三联信息
	public ProjectSanLianEntity getSanlianById( @Param("sanlianId")Long sanlianId);

	//获取三联信息最大编号
	public ProjectSanLianEntity getSanlianId();

	//删除三联信息
	public boolean deleteSanlian(@Param("ids")Long[] ids);
	//更新三联信息
	boolean updateByIds(ProjectSanLianEntity projectSanLianEntity);
	//保存三联信息
	boolean save(ProjectSanLianEntity projectSanLianEntity);
//	//获取用户信息
//	 SysUserEntity getSysById(@Param("userId")Long userId);

	//查询三联编号是否存在
	ProjectSanLianEntity getSanlianInfo( @Param("name")String name);

	 List<ProjectSanLianEntity> findList(
	 											@Param("name") String name,
											   @Param("ceoName") String ceoName,
											   @Param("paymentNuit") String paymentNuit,
											   @Param("contractSum") String contractSum,
											   @Param("projectName") String projectName,
											   @Param("ids") Long[] ids,
											   @Param("sql_filter") String sql_filter);
}

